﻿using FreeSql.DatabaseModel;using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using Newtonsoft.Json;
using FreeSql.DataAnnotations;

namespace Syx.Webapi.AppCode.Entities {

	[JsonObject(MemberSerialization.OptIn), Table(DisableSyncStructure = true)]
	public partial class DEATH {

		/// <summary>
		/// 死亡报告卡id
		/// </summary>
		[JsonProperty, Column(Name = "DEATH_ID", DbType = "NUMBER(22)", IsPrimary = true)]
		public decimal DEATHID { get; set; }

		/// <summary>
		/// 角色id
		/// </summary>
		[JsonProperty, Column(Name = "APP_USER_ID", DbType = "NUMBER(22)")]
		public decimal? APPUSERID { get; set; }

		/// <summary>
		/// 附件地址
		/// </summary>
		[JsonProperty, Column(Name = "APPENDIX_WAY", DbType = "VARCHAR2(500 BYTE)")]
		public string APPENDIXWAY { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(200 BYTE)")]
		public string BAK1 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(200 BYTE)")]
		public string BAK10 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(255 BYTE)")]
		public string BAK11 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(255 BYTE)")]
		public string BAK12 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(255 BYTE)")]
		public string BAK13 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(255 BYTE)")]
		public string BAK14 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(255 BYTE)")]
		public string BAK15 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(255 BYTE)")]
		public string BAK16 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(255 BYTE)")]
		public string BAK17 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(255 BYTE)")]
		public string BAK18 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(255 BYTE)")]
		public string BAK19 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(200 BYTE)")]
		public string BAK2 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(255 BYTE)")]
		public string BAK20 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(200 BYTE)")]
		public string BAK3 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(200 BYTE)")]
		public string BAK4 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(200 BYTE)")]
		public string BAK5 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(200 BYTE)")]
		public string BAK6 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(200 BYTE)")]
		public string BAK7 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(200 BYTE)")]
		public string BAK8 { get; set; }

		[JsonProperty, Column(DbType = "VARCHAR2(200 BYTE)")]
		public string BAK9 { get; set; }

		/// <summary>
		/// 死者生前诊断依据
		/// </summary>
		[JsonProperty, Column(Name = "BEFORE_BASIS", DbType = "VARCHAR2(500 BYTE)")]
		public string BEFOREBASIS { get; set; }

		/// <summary>
		/// 出生日期
		/// </summary>
		[JsonProperty, Column(Name = "BIRTH_DATA", DbType = "DATE(7)")]
		public DateTime? BIRTHDATA { get; set; }

		/// <summary>
		/// 国家或地区
		/// </summary>
		[JsonProperty, Column(DbType = "VARCHAR2(255 BYTE)")]
		public string COUNTRY { get; set; }

		/// <summary>
		/// 死者生前地址（常住地址）
		/// </summary>
		[JsonProperty, Column(Name = "DEAD_ADDRESS", DbType = "VARCHAR2(300 BYTE)")]
		public string DEADADDRESS { get; set; }

		/// <summary>
		/// 死者生前病史
		/// 及症状体征
		/// </summary>
		[JsonProperty, Column(Name = "DEAD_BINGSHI", DbType = "VARCHAR2(500 BYTE)")]
		public string DEADBINGSHI { get; set; }

		/// <summary>
		/// 死者生前工作单位
		/// </summary>
		[JsonProperty, Column(Name = "DEAD_COMPANY", DbType = "VARCHAR2(500 BYTE)")]
		public string DEADCOMPANY { get; set; }

		/// <summary>
		/// 年龄
		/// </summary>
		[JsonProperty, Column(Name = "DEATH_AGE", DbType = "VARCHAR2(255 BYTE)")]
		public string DEATHAGE { get; set; }

		/// <summary>
		/// 文化程度
		/// </summary>
		[JsonProperty, Column(Name = "DEATH_CULTURE", DbType = "VARCHAR2(255 BYTE)")]
		public string DEATHCULTURE { get; set; }

		/// <summary>
		/// 死亡日期
		/// </summary>
		[JsonProperty, Column(Name = "DEATH_DATE", DbType = "DATE(7)")]
		public DateTime? DEATHDATE { get; set; }

		/// <summary>
		/// 证件号码
		/// </summary>
		[JsonProperty, Column(Name = "DEATH_IDCARD", DbType = "VARCHAR2(255 BYTE)")]
		public string DEATHIDCARD { get; set; }

		/// <summary>
		/// 死者姓名
		/// </summary>
		[JsonProperty, Column(Name = "DEATH_NAME", DbType = "VARCHAR2(255 BYTE)")]
		public string DEATHNAME { get; set; }

		/// <summary>
		/// 民族
		/// </summary>
		[JsonProperty, Column(Name = "DEATH_NATION", DbType = "VARCHAR2(255 BYTE)")]
		public string DEATHNATION { get; set; }

		/// <summary>
		/// 死亡报告卡编号
		/// </summary>
		[JsonProperty, Column(Name = "DEATH_NUMBERS", DbType = "VARCHAR2(100 BYTE)")]
		public string DEATHNUMBERS { get; set; }

		/// <summary>
		/// 联系号码
		/// </summary>
		[JsonProperty, Column(Name = "DEATH_PHONE", DbType = "NUMBER(22)")]
		public decimal? DEATHPHONE { get; set; }

		/// <summary>
		/// 个人身份
		/// </summary>
		[JsonProperty, Column(Name = "DEATH_POLITICALSTATUS", DbType = "VARCHAR2(255 BYTE)")]
		public string DEATHPOLITICALSTATUS { get; set; }

		/// <summary>
		/// 性别
		/// </summary>
		[JsonProperty, Column(Name = "DEATH_SEX", DbType = "VARCHAR2(255 BYTE)")]
		public string DEATHSEX { get; set; }

		/// <summary>
		/// 有效身份证件类别
		/// </summary>
		[JsonProperty, Column(Name = "DEATH_TYPE", DbType = "VARCHAR2(255 BYTE)")]
		public string DEATHTYPE { get; set; }

		/// <summary>
		/// 报告科室
		/// </summary>
		[JsonProperty, Column(DbType = "VARCHAR2(100 BYTE)")]
		public string DEPARTMENT { get; set; }

		/// <summary>
		/// 部门id
		/// </summary>
		[JsonProperty, Column(Name = "DEPARTMENT_ID", DbType = "NUMBER(22)")]
		public decimal? DEPARTMENTID { get; set; }

		/// <summary>
		/// 疾病名称
		/// </summary>
		[JsonProperty, Column(Name = "DISEASE_NAME", DbType = "VARCHAR2(255 BYTE)")]
		public string DISEASENAME { get; set; }

		/// <summary>
		/// 填卡医生
		/// </summary>
		[JsonProperty, Column(DbType = "VARCHAR2(255 BYTE)")]
		public string DOCTOR { get; set; }

		/// <summary>
		/// 死者生前诊断依据：医生填卡日期
		/// </summary>
		[JsonProperty, Column(Name = "DOCTOR_DATE", DbType = "DATE(7)")]
		public DateTime? DOCTORDATE { get; set; }

		/// <summary>
		/// 附件
		/// </summary>
		[JsonProperty, Column(Name = "ENTRY_APPENDIX", DbType = "VARCHAR2(500 BYTE)")]
		public string ENTRYAPPENDIX { get; set; }

		/// <summary>
		/// 致死的主要疾病诊断
		/// </summary>
		[JsonProperty, Column(Name = "FATAL_DISEASE", DbType = "VARCHAR2(100 BYTE)")]
		public string FATALDISEASE { get; set; }

		/// <summary>
		/// 直属上级
		/// </summary>
		[JsonProperty, Column(Name = "HIGHER_LEVEL", DbType = "VARCHAR2(100 BYTE)")]
		public string HIGHERLEVEL { get; set; }

		/// <summary>
		/// 死前最高诊断单位
		/// </summary>
		[JsonProperty, Column(Name = "HIGHEST_UNIT", DbType = "VARCHAR2(100 BYTE)")]
		public string HIGHESTUNIT { get; set; }

		/// <summary>
		/// 户籍地址
		/// </summary>
		[JsonProperty, Column(DbType = "VARCHAR2(200 BYTE)")]
		public string HUJI { get; set; }

		/// <summary>
		/// 住院号
		/// </summary>
		[JsonProperty, Column(Name = "INPATIENT_NUMBER", DbType = "VARCHAR2(255 BYTE)")]
		public string INPATIENTNUMBER { get; set; }

		/// <summary>
		/// 审批状态
		/// </summary>
		[JsonProperty, Column(Name = "INTERT_STATUS", DbType = "VARCHAR2(100 BYTE)")]
		public string INTERTSTATUS { get; set; }

		/// <summary>
		/// 发病至死亡时间间隔
		/// </summary>
		[JsonProperty, Column(Name = "INTERVAL_A", DbType = "VARCHAR2(255 BYTE)")]
		public string INTERVALA { get; set; }

		/// <summary>
		/// 发病至死亡时间间隔
		/// </summary>
		[JsonProperty, Column(Name = "INTERVAL_B", DbType = "VARCHAR2(255 BYTE)")]
		public string INTERVALB { get; set; }

		/// <summary>
		/// 发病至死亡时间间隔
		/// </summary>
		[JsonProperty, Column(Name = "INTERVAL_C", DbType = "VARCHAR2(255 BYTE)")]
		public string INTERVALC { get; set; }

		/// <summary>
		/// 发病至死亡时间间隔
		/// </summary>
		[JsonProperty, Column(Name = "INTERVAL_D", DbType = "VARCHAR2(255 BYTE)")]
		public string INTERVALD { get; set; }

		/// <summary>
		/// 调查者签名
		/// </summary>
		[JsonProperty, Column(Name = "INVESTIGATION_AUTOGRAPH", DbType = "VARCHAR2(100 BYTE)")]
		public string INVESTIGATIONAUTOGRAPH { get; set; }

		/// <summary>
		/// 调查日期
		/// </summary>
		[JsonProperty, Column(Name = "INVESTIGATION_DATE", DbType = "DATE(7)")]
		public DateTime? INVESTIGATIONDATE { get; set; }

		/// <summary>
		/// 联系电话
		/// </summary>
		[JsonProperty, Column(Name = "INVESTIGATION_PHONE", DbType = "VARCHAR2(100 BYTE)")]
		public string INVESTIGATIONPHONE { get; set; }

		/// <summary>
		/// 是否启用
		/// </summary>
		[JsonProperty, Column(Name = "IS_USE", DbType = "VARCHAR2(100 BYTE)")]
		public string ISUSE { get; set; }

		/// <summary>
		/// 婚姻状况
		/// </summary>
		[JsonProperty, Column(DbType = "VARCHAR2(255 BYTE)")]
		public string MARRY { get; set; }

		/// <summary>
		/// 发病到死亡时间
		/// </summary>
		[JsonProperty, Column(Name = "MORBIDITY_DATE", DbType = "DATE(7)")]
		public DateTime? MORBIDITYDATE { get; set; }

		[JsonProperty, Column(Name = "NODE_NO", DbType = "VARCHAR2(100 BYTE)")]
		public string NODENO { get; set; }

		/// <summary>
		/// 2、其他疾病诊断(促进死亡，但与导致死亡无关的其他重要情况)	
		/// </summary>
		[JsonProperty, Column(Name = "OTHER_DISEASES", DbType = "VARCHAR2(100 BYTE)")]
		public string OTHERDISEASES { get; set; }

		/// <summary>
		/// 发病至死亡时间间隔
		/// </summary>
		[JsonProperty, Column(Name = "OTHER_INTERVAL", DbType = "VARCHAR2(255 BYTE)")]
		public string OTHERINTERVAL { get; set; }

		/// <summary>
		/// 死亡儿童家长姓名
		/// </summary>
		[JsonProperty, Column(Name = "PARENTS_CHILDREN", DbType = "VARCHAR2(100 BYTE)")]
		public string PARENTSCHILDREN { get; set; }

		/// <summary>
		/// 死亡地点
		/// </summary>
		[JsonProperty, Column(Name = "PLACE_DEATH", DbType = "VARCHAR2(255 BYTE)")]
		public string PLACEDEATH { get; set; }

		/// <summary>
		/// 死亡时是否处于妊娠期或妊娠终止后42天内
		/// </summary>
		[JsonProperty, Column(DbType = "VARCHAR2(255 BYTE)")]
		public string PREGNANCY { get; set; }

		/// <summary>
		/// sqlservice表
		/// </summary>
		[JsonProperty, Column(StringLength = 200)]
		public string RELID { get; set; }

		/// <summary>
		/// 报告单位
		/// </summary>
		[JsonProperty, Column(Name = "REPORTING_UNIT", DbType = "VARCHAR2(100 BYTE)")]
		public string REPORTINGUNIT { get; set; }

		/// <summary>
		/// 根本死亡原因
		/// </summary>
		[JsonProperty, Column(Name = "ROOT_DEATH", DbType = "VARCHAR2(100 BYTE)")]
		public string ROOTDEATH { get; set; }

		/// <summary>
		/// 家属地址或工作单位
		/// </summary>
		[JsonProperty, Column(Name = "SIB_ADDRESS", DbType = "VARCHAR2(400 BYTE)")]
		public string SIBADDRESS { get; set; }

		/// <summary>
		/// 可联系家属姓名
		/// </summary>
		[JsonProperty, Column(Name = "SIB_NAME", DbType = "VARCHAR2(255 BYTE)")]
		public string SIBNAME { get; set; }

		/// <summary>
		/// (A)直接导致死亡的疾病或情况
		/// </summary>
		[JsonProperty, Column(Name = "SITUATION_A", DbType = "VARCHAR2(100 BYTE)")]
		public string SITUATIONA { get; set; }

		/// <summary>
		/// (B)引起(A)疾病或情况
		/// </summary>
		[JsonProperty, Column(Name = "SITUATION_B", DbType = "VARCHAR2(100 BYTE)")]
		public string SITUATIONB { get; set; }

		/// <summary>
		/// (C)引起(B)疾病或情况
		/// </summary>
		[JsonProperty, Column(Name = "SITUATION_C", DbType = "VARCHAR2(100 BYTE)")]
		public string SITUATIONC { get; set; }

		/// <summary>
		/// (D)引起(C)疾病或情况	
		/// </summary>
		[JsonProperty, Column(Name = "SITUATION_D", DbType = "VARCHAR2(100 BYTE)")]
		public string SITUATIOND { get; set; }

		/// <summary>
		/// 死因推断
		/// </summary>
		[JsonProperty, Column(Name = "SIYIN_INFER", DbType = "VARCHAR2(100 BYTE)")]
		public string SIYININFER { get; set; }

		/// <summary>
		/// 与死者关系
		/// </summary>
		[JsonProperty, Column(Name = "SIZHE_RELATIONSHIP", DbType = "VARCHAR2(100 BYTE)")]
		public string SIZHERELATIONSHIP { get; set; }

		/// <summary>
		/// 员工id
		/// </summary>
		[JsonProperty, Column(Name = "STAFF_ID", DbType = "NUMBER(22)")]
		public decimal? STAFFID { get; set; }

		/// <summary>
		/// 被调查者姓名
		/// </summary>
		[JsonProperty, Column(Name = "SURVEYED_NAME", DbType = "VARCHAR2(100 BYTE)")]
		public string SURVEYEDNAME { get; set; }

		/// <summary>
		/// 3、不明死因的主要症状体征
		/// </summary>
		[JsonProperty, Column(Name = "UNKNOWN_DEATH", DbType = "VARCHAR2(100 BYTE)")]
		public string UNKNOWNDEATH { get; set; }

		/// <summary>
		/// 联系地址或工作单位
		/// </summary>
		[JsonProperty, Column(Name = "WORK_UNIT", DbType = "VARCHAR2(100 BYTE)")]
		public string WORKUNIT { get; set; }

	}

}
